<%@ page language="java" import="java.util.*,java.sql.*" contentType="text/html; charset=utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<jsp:useBean id="db" class="connBean.ConnDB" scope="page" />

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>欧米购商城-个人资料</title>
    
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	
	
	<link rel="stylesheet" href="css/style.css" type="text/css" media="all" />
	<!--[if lte IE 6]><link rel="stylesheet" href="css/ie6.css" type="text/css" media="all" /><![endif]-->
	
	<meta name="keywwords" content="Shop Around - Great free html template for on-line shop. Use it as a start point for your on line business. The template can be easily implemented in many open source E-commerce platforms" />
	<meta name="description" content="Shop Around - Great free html template for on-line shop. Use it as a start point for your on line business. The template can be easily implemented in many open source E-commerce platforms" />
	
	<!-- JS -->
	<script src="js/jquery-1.4.1.min.js" type="text/javascript"></script>	
	<script src="js/jquery.jcarousel.pack.js" type="text/javascript"></script>	
	<script src="js/jquery-func.js" type="text/javascript"></script>	
	<!-- End JS -->
	
	
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->
<style type="text/css">
#content {
	float: left;
	width: 960px;
}
</style>


  </head>
<body>
<%request.setCharacterEncoding("UTF-8");
 %>
<jsp:include page="customerService.jsp"></jsp:include>
  <!-- Shell -->	
<div class="shell">
	
	<!-- Header -->	
	<div id="header">
		<h1 id="logo"><a href="index.jsp">欧米购</a></h1>
		<!-- Cart -->
		<div id="cart" align="center">
		    <%if (session.getAttribute("username") ==null||session.getAttribute("username")==""){
		     %>您好，您还未登录！
		     <div class="cl">&nbsp;</div>
		     <a href="login.jsp" class="c2-link">[登录]</a>
		     <a href="addUser.jsp" class="c2-link">[免费注册]</a>
		     <%}else{
		      %>欢迎您，<%=session.getAttribute("username") %>
		     <a href="logout.jsp" class="c2-link">[退出]</a>
		     <div class="cl">&nbsp;</div>
		     <a href="personalData.jsp" class="c2-link">个人资料</a>
			<a href="shoppingCart.jsp" class="cart-link">我的购物车</a>
			<%} %>
		</div>
		<!-- End Cart -->
		
		<!-- Navigation -->
		<div id="navigation">
			<ul>
			    <li><a href="index.jsp" >主页</a></li>
          <%
          db.OpenConn();
          db.createStmt();
          String sql="select * from main_type";
          ResultSet rs=db.Query(sql);
          while(rs.next()){
           %>
          <li><a href="index_main_Type.jsp?maintype_id=<%=rs.getInt("t_id") %>" ><%=rs.getString("t_name") %></a></li>
          <%}
          db.closeStmt();
          db.closeConn(); 
          %>
			</ul>
		</div>
		<!-- End Navigation -->
	</div>
	<!-- End Header -->
	
	<!-- Main -->
	<div id="main">
		<div class="cl">&nbsp;</div>
		
		<!-- Content -->
		<div id="content">
			<!-- PersonalData -->
			<div class="box categories">
				<h2>找回密码<span></span></h2>
				<div class="box-content" align="center">
				    <%
				    String name=request.getParameter("username");
				    String question=request.getParameter("question");
				    String answer=request.getParameter("answer");
				    String newpassword=request.getParameter("newpassword");
				    db.OpenConn();
				    db.createStmt();
				    String sql2="select * from customer where c_name='"+name+"' and c_question='"+question+"' and c_answer='"+answer+"'";
				    ResultSet customers=db.Query(sql2);
				    if(customers.next())
				    {
				        String sql3="update customer set c_pass='"+newpassword+"' where c_id="+customers.getInt("c_id");
				        int resulut=db.Update(sql3);
				        if(resulut!=0)
				        {
				            out.println("重置成功：重置密码为："+newpassword+"，3秒后返回登录界面！");
				            response.setHeader("Refresh","3;URL=login.jsp");
				        }
				        else
				        {
				            out.println("修改失败，系统错误！");
				            response.setHeader("Refresh","3;URL=personalData_Repassword.jsp");
				        }
				          
				    }else
				    {
				    out.println("错误：问题答案错误！3秒后返回！");
				     response.setHeader("Refresh","3;URL=personalData_Repassword.jsp");
				    }%>
				</div>
			</div>
			<!-- End PersonalData -->
		</div>
		<!-- End Content -->
		
	</div>
	<!-- End Main -->
	
	<!-- Side Full -->
	<div class="side-full">
		
		<!-- More Products -->
		<div class="more-products">
			<div class="more-products-holder">
				<ul>
				    <li><a href="#"><img src="images/small1.jpg" alt="" /></a></li>
				    <li><a href="#"><img src="images/small2.jpg" alt="" /></a></li>
				    <li><a href="#"><img src="images/small3.jpg" alt="" /></a></li>
				    <li><a href="#"><img src="images/small4.jpg" alt="" /></a></li>
				    <li><a href="#"><img src="images/small5.jpg" alt="" /></a></li>
				    <li><a href="#"><img src="images/small6.jpg" alt="" /></a></li>
				    <li><a href="#"><img src="images/small7.jpg" alt="" /></a></li>
				    <li><a href="#"><img src="images/small1.jpg" alt="" /></a></li>
				    <li><a href="#"><img src="images/small2.jpg" alt="" /></a></li>
				    <li><a href="#"><img src="images/small3.jpg" alt="" /></a></li>
				    <li><a href="#"><img src="images/small4.jpg" alt="" /></a></li>
				    <li><a href="#"><img src="images/small5.jpg" alt="" /></a></li>
				    <li><a href="#"><img src="images/small6.jpg" alt="" /></a></li>
				    <li><a href="#"><img src="images/small7.jpg" alt="" /></a></li>
				    <li><a href="#"><img src="images/small1.jpg" alt="" /></a></li>
				    <li><a href="#"><img src="images/small2.jpg" alt="" /></a></li>
				    <li><a href="#"><img src="images/small3.jpg" alt="" /></a></li>
				    <li><a href="#"><img src="images/small4.jpg" alt="" /></a></li>
				    <li><a href="#"><img src="images/small5.jpg" alt="" /></a></li>
				    <li><a href="#"><img src="images/small6.jpg" alt="" /></a></li>
				    <li class="last"><a href="#"><img src="images/small7.jpg" alt="" /></a></li>
				</ul>
			</div>
			<div class="more-nav">
				<a href="#" class="prev">previous</a>
				<a href="#" class="next">next</a>
			</div>
		</div>
		<!-- End More Products -->
		
		<!-- Text Cols -->
		<div class="cols">
			<div class="cl">&nbsp;</div>
			<div class="col">
				<h3 class="ico ico1">Donec imperdiet</h3>
				<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec imperdiet, metus ac cursus auctor, arcu felis ornare dui.</p>
				<p class="more"><a href="#" class="bul">Lorem ipsum</a></p>
			</div>
			<div class="col">
				<h3 class="ico ico2">Donec imperdiet</h3>
				<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec imperdiet, metus ac cursus auctor, arcu felis ornare dui.</p>
				<p class="more"><a href="#" class="bul">Lorem ipsum</a></p>
			</div>
			<div class="col">
				<h3 class="ico ico3">Donec imperdiet</h3>
				<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec imperdiet, metus ac cursus auctor, arcu felis ornare dui.</p>
				<p class="more"><a href="#" class="bul">Lorem ipsum</a></p>
			</div>
			<div class="col col-last">
				<h3 class="ico ico4">Donec imperdiet</h3>
				<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec imperdiet, metus ac cursus auctor, arcu felis ornare dui.</p>
				<p class="more"><a href="#" class="bul">Lorem ipsum</a></p>
			</div>
			<div class="cl">&nbsp;</div>
		</div>
		<!-- End Text Cols -->
		
	</div>
	<!-- End Side Full -->
	
	<!-- Footer -->
	<div id="footer">
		<p class="left">
			<a href="index.jsp">Home</a>
			<span>|</span>
			<a href="#">Support</a>
			<span>|</span>
			<a href="#">My Account</a>
			<span>|</span>
			<a href="#">The Store</a>
			<span>|</span>
			<a href="#">Contact</a>
		</p>
		<p class="right">
			&copy; 2015 OMEGO Shopping Design by &nbsp;<a href="#" target="_blank" title="The Sweetest CSS Templates WorldWide">欧米购创意小组</a>
		</p>
	</div>
	<!-- End Footer -->
	
</div>	
<!-- End Shell -->
	
	
</body>
</html>
